Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$DBLINK

This view describes all database links (links with `IN_TRANSACTION = YES`) opened by the session issuing the query on `V$DBLINK`. These database links must be committed or rolled back before being closed.

Column | Datatype | Description
--- | --- | ---
`DB_LINK` | `VARCHAR2(128)` | Name of the database link
`OWNER_ID` | `NUMBER` | Owner of the database link UID
`LOGGED_ON` | `VARCHAR2(3)` | Whether the database link is currently logged on
`HETEROGENEOUS` | `VARCHAR2(3)` | Whether the database link is heterogeneous
`PROTOCOL` | `VARCHAR2(6)` | Communication protocol for the database link
`OPEN_CURSORS` | `NUMBER` | Whether there are open cursors for the database link
`IN_TRANSACTION` | `VARCHAR2(3)` | Whether the database link is currently in a transaction
`UPDATE_SENT` | `VARCHAR2(3)` | Whether there has been an update on the database link
`COMMIT_POINT_STRENGTH` | `NUMBER` | Commit point strength of the transactions on the database link